package com.ruoyi.system.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.common.annotation.DataSource;
import com.ruoyi.common.enums.DataSourceType;
import com.ruoyi.system.domain.OtherBlocketRecord;
import com.ruoyi.system.domain.OtherManualMicOrderRecord;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.HashMap;
import java.util.List;

@DataSource(value = DataSourceType.SLAVE)
public interface OtherManualMicOrderRecordMapper extends BaseMapper<OtherManualMicOrderRecord> {

    @Select("select wxid ,displayName, SUM(count) as totalvalue from ManualMicOrderRecord where roomID=  #{roomId}  and roundDate BETWEEN #{startDate} AND #{endDate}  group by wxid,displayName")
    public List<HashMap> getManualMicOrderRecord(@Param("roomId") String roomID, @Param("startDate") String startDate, @Param("endDate")String endDate, @Param("startTime")String startTime, @Param("endTime")String endTime);
}
